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.
- 1 Answers
- 3032 Views
- TATA, I also Faced
- E-Mail Answers
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 |
How do you recover rows from a failed session
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
what is system requirement(SR) & business requirement(BR)?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Explain sessions and how many types of sessions are there?
If I am having 6 flat files in data. How can you load the data at a time
What are the modules in Power Center
How we can create indexes after completing the load process?
What is a surrogate key?
Explain in detail scd type 2 through mapping.
Teradata 
