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
- 9158 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
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is a difference between complete, stop and abort?
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 joiner change?
What is Index Caches size?
What is resilience time?
tell me 5 session failure in real time how can you solve that in your project?
How to join three sources using joiner? Explain though mapping flow.
where to store informatica rejected data? How to extract the informatica rejected data?
Explain why we use partitioning the session in informatica?
What is complex mapping?
