A Flat file located in unix source folder. data transfer every day 8 am.
can ask 5 question for above scenario validation.
recently i have faced this question.
Answer / vivekk
1) Need to check the file permissions in unix!
2) Need to check the owner of that file!
3) Does the file would be transferred from some other operating system (Windows, MAC), if so we need to perform Dos2Unix in order to use it in unix.
4) What happens if the file has not received at 8 AM
5) Does it has fixed length
6) What kind of delimiters used
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
how to get flatfile containg 10 records half records one target another half another target
What are the disadvantages of Sequence Generator T/R?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What is a surrogate key?
How do you use reject loader.
How can you run a session without using server manager?
what is mean by throghput? in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is incremantal aggregation?