Interested to Buy Any Domain ? << Click Here >> for more details...
my source has 2 columns. 1st column data: ABC ABC ABC XYZ
and 2nd column data: 1 2 3 4. And my target should be ABC 1 2
3, XYZ 4
- 2 Answers
- 7169 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
S-->SQ-->EXP-->AGG--->TGT
EXP:
Create Variable port:
res: decode(col1=prev_col1,concat(res,col2), col2)
O_put: res
pre_col1=col1
AGG:
group by col1
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the reusable transformation?
How can you define user defied event?
Enlist some properties of sessions.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to convert multiple rows to single row (multiple columns) in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
What are the reusable transformations?
What is informatica metadata and where is it stored?
Define enterprise data warehousing?
What are the data movement modes in informatica?
How to load a Dimension ? and how to load a fact table?
Have you worked with/created Parameter file
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the advantages of using informatica as an etl tool over teradata?
What are the designer tools for creating transformations?
