Interested to Buy Any Domain ? << Click Here >> for more details...
In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
- 5 Answers
- 9969 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopanwita
There is a stage in Datastage,Pivot to do normalization.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is standalone command task?
What is the benefit of session partitioning?
What are ETL Tools?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to load last n records of file into target table - informatica
can anyone explain me about retail domain project in informatica?
Can anyone tell me the new features in Informatica 9 Version?
How do you load alternate records into different tables through mapping flow?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is the size of your data warehousing?
What are the uses of etl tools?
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
How do you promote a non-reusable transformation to reusable transformation?
