Interested to Buy Any Domain ? << Click Here >> for more details...
I have source data like this
col1 col2 col3
5 3 8
6 2 9
7 1 10
and i want to get target as
col1 col2 col3
5 1 8
6 2 9
7 3 10
which transformation i have to use and how?
- 3 Answers
- 6365 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
Take col1 and col3 in pipeline with a sequece generator,
and sorted values of col 2 in another pipeline with
sequence generator. Join both pipelines by sequence values
and send it to target.
for more details.. look into 5th page, last question, last
answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / gd
sq-->Sorter t/r--->target
In sorter check the sorted port for col2 with ASC.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the types of lookup?
Design time, run time. If you don't create parameter what will happen
what are the deliverables?in your project?
How do you load first and last records into target table?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
What are the types of data warehouses?
tell me 5 session failure in real time how can you solve that in your project?
During the running session, output files are created by informatica server. Enlist few of them.
Can we override a native sql query within informatica?
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 informatica? Why do we need it?
what is DSS?
Teradata 
