Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8021 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva
Import the file with comma delimited, so that, it creates
with 5 columns c1,c2,c3,c4,c5
take the mapping as follows:
SQ --> Exp -->filter--> target_
in the expression take a variable port and assign the value
as iif(c1 = 1,concatenate all the c2,c3,c4,c5 otherwise
concatenate varibale post value with c2,c3,c4,c5)
then you will get as follows:
c1, v_p
1, 'x1,x2,x3,<null>'
2, 'x1,x2,x3,<null>,a1,a2,<null>,<null>'
3, 'x1,x2,x3,<null>,a1,a2,<null>,<null>,b1,b2,b3,b4'
1, 'y1,y2,y3,<null>
2, 'y1,y2,y3,<null>,c1,c2,c3,<null>
3, 'y1,y2,y3,<null>,c1,c2,c3,<null>,d1,d2,<null>,<null>'
you can lso ingnore the unncessary columns where ever
filter out only c1 = 3 to the target
It helps you to succeed..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
Where can we find the throughput option in informatica?
What is aggregate cache in aggregator transformation?
How to update or delete the rows in a target, which do not have key fields?
Explain Dataware house architecture .how data flow from intial to end?
What are the different types of repositories created using informatica?
What is the maplet?
What do you understand by a term domain?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the databases that informatica can connect to windows?
Explain the features of connected and unconnected lookup.
Briefly define a session task?
Global and Local shortcuts. Advantages.
Define Pmrep command?
what are the Methods For Creating Reusable Transformations?
