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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the sql query overwrite in source qualifier in informatica
Write the advantages of partitioning a session?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain lookup transformation is active in informatica
What are connected or unconnected transformations?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the code page compatibility?
what is size of u r database?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is repository manager?
How many ways are there to do 'remove duplicate records in informatica'?
In which transformation you cannot drag ports into it?
Explain scd type 3 through mapping.