Experts In Informatica/sql/shellscripting

[Srinidhi]

Say there is a emp table with salaries listed. From that table insert  the data to target where sal<3000 and reject other rows.

[Srinidhi]

Suppose you are importing a flat file emp.csv and hire_date column is in numeric format, like 20101111 .Our objective is convert it to date,with a format 'YYYYMMDD'.

 

[anandam2012]

good post

[Srinidhi]

I have flat file as a source which contains N number of records. How to load half of the source data into the target table in the first session run and the remaining half of the records in the second session run. Assume that the source data does not change between session runs.

[Srinidhi]

How to route unique rows to one table and duplicate ones to another table?

[gabbarsingh1]

I have flat file as a source which contains N number of records. How to load half of the source data into the target table in the first session run and the remaining half of the records in the second session run. Assume that the source data does not change between session runs.

 

sare ippudu assume cheskuntadu... ade nerchukuntadu,... repu job lo join aina tarvatha aa assumption wrong aithe,... :3D_Smiles:

[Srinidhi]

sare ippudu assume cheskuntadu... ade nerchukuntadu,... repu job lo join aina tarvatha aa assumption wrong aithe,... :3D_Smiles:

andaru nee antha inti undaru 

[gabbarsingh1]

andaru nee antha inti undaru 

 

ori nee eshalooooooo :3D_Smiles:

[Srinidhi]

ori nee eshalooooooo :3D_Smiles:

close your eyes and solve all the above 

[ronitreddy]

aaaaa

[venky29]

 

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

 

 

use normalizer with 3 occurences

 

or create 3 target instances use 3 exp t/r and load to 3 target each col into each target
 

[venky29]

 

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

 

 

use normalizer with 3 occurences

 

or create 3 target instances use 3 exp t/r and load to 3 target each col into each target
 

[venky29]

 

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

 

 

use normalizer with 3 occurences

 

or create 3 target instances use 3 exp t/r and load to 3 target each col into each target
 

[venky29]

 

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

 

 

use normalizer with 3 occurences

 

or create 3 target instances use 3 exp t/r and load to 3 target each col into each target
 

[venky29]

 

We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:

 

Col1         Col2         Col3

a         b         c

 

There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:

 

Col

a

b

c

 

 

normalizer with 3 occurences

sq nundi 3 target instances load

or use router and write expression to load particular column