sudheer


{ City } chennai
< Country > india
* Profession *
User No # 108754
Total Questions Posted # 1
Total Answers Posted # 7

Total Answers Posted for My Questions # 7
Total Views for My Questions # 7770

Users Marked my Answers as Correct # 5
Users Marked my Answers as Wrong # 4
Questions / { sudheer }
Questions Answers Category Views Company eMail

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

Accenture,

7 Informatica 7770



Answers / { sudheer }

Question { 8819 }

In Datastage, we have row generator stage to generate dummy
row.

Is there any such transformation in Informatica.

Thanks in advance,
Kumar


Answer

Yes,Sequence Generator.

Is This Answer Correct ?    0 Yes 2 No

Question { 5603 }

Please create a mapping where I have source which has one column with name like Aman_Gupta
Rakesh_Mehra
Sachin_More
I want the target field should contain the name in reverse order i.e Gupta_Aman
Mehra_Rakesh
More_Sachin.

Can you please tell me what transformation would be needed to do this.


Answer

Can you try reverse function in informatica....

Is This Answer Correct ?    0 Yes 1 No


Question { CTS, 8535 }

write a query to get maximum salary from the employers table
without duplicates....kindly help me


Answer

MAX(SAL) will not give duplicate records in a single group

Is This Answer Correct ?    1 Yes 0 No

Question { TCS, 5275 }

i have a source table

ID NAME SAL

101 A 1000
102 B 2000
103 C 1500

target load should be

ID NAME SAL

101 A 1000
101 B 2000
101 C 1500
102 A 1000
102 B 2000
102 C 1500
103 A 1000
103 B 2000
103 C 1500


Answer

SELECT F1.COL1,F2.COL2,F2.COL3 FROM A F1,A F2 ORDER BY 1,2

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 9256 }

create a mapping to retrieve the employees who are getting
salary greater than average salary?


Answer

go with this order EXP, AGG, JOINER, FILTER

this will work

Is This Answer Correct ?    1 Yes 0 No

Question { Puma, 13299 }

Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation


Answer

 The Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations. For example, one branch in amapping contains an Update Strategy transformation that flags a row for delete. Another branch contains an Update Strategy transformation that flags a row for insert. If you connect these transformations to a single transformation input group, the Integration Service cannot combine the delete and insert operations for the row.

Is This Answer Correct ?    3 Yes 1 No

Question { TCS, 8038 }

3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?


Answer

Along with the above suggestions......

Better to use partitioning (single or multiple thread) and and increase the commit level to 50 lacs. Better to load first flat file instead of loading into table.
then if u r db is oracle better to use sql loader to load data from file to table.If DB2 than use db2 loader.

Is This Answer Correct ?    0 Yes 0 No