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 |
what is the look up transformation?
What does cheating measurement mean?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what is the drillup & drill down?and use of the drill up and drill down?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
connected and unconnected lookups?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How will you display "Mr" for male & "Mrs" for female in target table?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
How can you join two tables without any common column present in them?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Which version configuration tool used in ur project?