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
- 6484 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 is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Without using any transformations how u can load the data into target?
What is meant by active and passive transformation?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
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?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
Explain the types of transformations?
Briefly define reusable transformation?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Why the workflow is failed after running two hours in informatica?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
How do you join more than 3 flat files in informatica?
Teradata 
