I have a file with data comming as
1,x1,x2,x3
2,a1,a2
3,b1,b2,b3,b4
1,y1,y2,y3
2,c1,c2,c3
3,d1,d2
my out put should be as follows
x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4
y1,y2,y3,c1,c2,c3,d1,d2,<null>
Please let me know how can we acheive this in informatica
Thanks in advance
- 4 Answers
- 6711 Views
- I also Faced
- E-Mail Answers
Answer Posted / bebo
use comma delimiter..infa will identify the null values
while importing the flat file
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to generate or load values in to the target table based on a column value using informatica etl tool.
Differentiate between source qualifier and filter transformation?
What do you mean by blocking transformation?
What is the use of transformation?
How do you promote a non-reusable transformation to reusable transformation?
How to load data in informatica ?
Tell me about MD5 functions in informatica
Can you use flat files in Mapplets.
What is Index Caches size?
Briefly explain the aggregator transformation?
what is the -ve test case in your project.
Explain load alternative records / rows into multiple targets - informatica
What are multi-group transformations?
How can a transformation be made reusable?
How do you load unique records into one target table and duplicate records into a different target table?
