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
- 7856 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 do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Describe an informatica powercenter?
What is a surrogate key?
Separate from a database, an information bazaar, and an information stockroom?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain constraint based loading in informatica
What are the types of lookup transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is mean by complex business rule ?
What is meant by incremental aggregation?
What are the settings that you use to configure the joiner transformation?
What is an unconnected transformation?
Can we create multiple integration service on single repository?
Enlist the differences between database and data warehouse.
