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
- 8098 Views
- I also Faced
- E-Mail Answers
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 facttable granularity?
Are there any types of Dynamic Caches in informatica
what are the row and column separations in Flat Files
Can any one explain or sujjest some sites for scd mappings.Thank you
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
what are the real time problems generally come up while doing or running mapping or any transformation?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Enlist the differences between database and data warehouse.
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Teradata 
