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 Posted / 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 |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
have u done any performance tuning? how u ll do?
How identifying bottlenecks in various components of informatica and resolving them?
What are the different types of transformation available in informatica.
How to generate sequence numbers?
What is a mapplet/worklet in informatica?
On which transformations you created partitions in your project?
How do you set a varible in incremental aggregation
Explain why we use partitioning the session in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
According to his methodology what all you need before you build a datawarehouse
pmscmd startworkflow -sv
What are session parameters ? How do you set them?
Differentiate between reusable transformation and mapplet.