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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pandu
u can use sq transformation .
start value 1,
incremental value 1,
reset value:slect,
and use the rank transformation.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rahul
use an exp t/r,
take an variable port as count = 0
keep inc the count by 1 and place a conditin if count > 4 ,
than set count = 0
and in other variable port ypu concate the columns value.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / bebo
use comma delimiter..infa will identify the null values
while importing the flat file
Is This Answer Correct ? | 0 Yes | 2 No |
How can we remove the duplicates from flat file source?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Make a note of the quantity vaults made in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
what transformations are used for Variable port?
what is lookup chache?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
star and snowflake schema?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What is a transaction control transformation?