COL1,COL2
ABC,1
XYZ,2
HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT
FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20)
O/P IS
COL1,COL2
ABC,2
XYZ,1
- 0 Answers
- 1539 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is target designer and target load order?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
In which transformation you cannot drag ports into it?
without matching columns in two tables. how can you join
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
difference between source based commit? and target based commit? which is better with respect to performance?
What is decode in informatica?
list out all the transformations which use cache?
What is the sql query overwrite in source qualifier in informatica
Enlist the various types of transformations.
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
Teradata 
