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 / 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 |
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
What is difference between a gateway node and worker node?
Explain informatica architecture - version 8 / 9
HOW TO YOU LOAD TIME DIMENSION
what is difference between dimention table and fact table?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Using Expression transformation how to remove duplicate records from a relational source?
What is the benefit of partitioning a session?
What are the differences between a connected lookup and unconnected lookup?