Hi experts,
> I 'm having data like this and it's in flat file.
> sno,name,marks,result
> 1, ak, 80,p
> 2, , ,20,f
> 3,jack,55,p
>
> now in the second row a comma(,) is placed instead of
name(char).
>
> when importing into SQ , in flat file wizard the num of
columns increased to 5 instead of 4.
>
> could you tell me how to over come this issue.........
Answer Posted / chiky
EDIT MANUALLY IN FLATFILE.
REPLACE IT AS SOMEOTHER CHARACTER.
AND PASS IN MAPPING. iN MAPPING YOU CAN REPLACE.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
Do you find any difficulty while working with flat files as source and target?
During the running session, output files are created by informatica server. Enlist few of them.
Differentiate between reusable transformation and mapplet.
How can we update a record in the target table without using update strategy?
Explain the difference between mapping parameter and mapping variable?
permutations of mapplet
my source is junk data how will u remove that junk data by using unix please any one replay me
What is Cognos script editor?
On which transformations you created partitions in your project?
Why is sorter an active transformation?
Explain the types of transformations?
Explain the tuning lookup transformation - informatica
What are Dimensional table?
Explain sessions?