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


Please Help Members By Posting Answers For Below Questions

How do you update the records with or without using update strategy?

656


What is InformaticaPowerCenter?

679


What are different types of transformations available in informatica?

580


State the differences between sql override and lookup override?

613


How is union transformation utilized?

562






Did u used latest transformations of 8.6.0? for what?

1471


In warehouses how many schemas are there?

577


What is incremental aggregation?

570


Which means the first record should come as last record and last record should come as first record and load into the target file?

607


COM components can be used in Informatica

1867


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.

1037


is it possible to index the data in cache of lkp transformation ?

1517


What is aggregate cache in aggregator transformation?

627


What is a dimensional model?

579


Performance tuning in UNIX for informatica mappings?

2131