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.........
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
How to load relational source into file target?
what is song in infrmatica...?
How the Informatica Server reads perameter file?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What are the phases in SDLC?
How can u work with remote database in informatica?did you work directly by using remote connections?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,