There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?



There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How ca..

Answer / harleen65

if [[ -s $FILE ]] ; then
echo "$FILE has data."
else
echo "$FILE is empty."
fi ;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,


The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  






Enlist few areas or real-time situations where informatica is required.

0 Answers  


what is the flow?

1 Answers  


What is Session and Batches?

0 Answers   Informatica,


we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  


Categories