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.



A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for a..

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

Post New Answer

More Informatica Interview Questions

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


How can we use batches?

0 Answers  


Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  






waht is dataware house

2 Answers  


How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,


Explain the different kinds of facts.

0 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


Categories