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
What is informatica? Why do we need it?
How do you change a non-reusable transformation to reusable transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
How do you take back up of repository?
What are the reusable transformations?
Explain sessions and how many types of sessions are there?
What are the restrictions of union transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Define update strategy?
How do you handle two sessions in Informatica
What is the commit type if you have a transaction control transformation in the mapping?
How to convert multiple rows to single row (multiple columns) in informatica
What is InformaticaPowerCenter?
Whats there in global repository
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?