How do u identify or filter out a 0 byte file available in a
folder by using UNIX command?
Answer / raj
Most files of the following command output will be lock-files and place holders created by other applications.
# find ~ -empty
List all the empty files only in your home directory.
# find . -maxdepth 1 -empty
List only the non-hidden empty files only in the current directory.
# find . -maxdepth 1 -empty -not -name ".*"
Is This Answer Correct ? | 1 Yes | 1 No |
What does update strategy mean, and what are the different option of it?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Explain the difference between a data warehouse and a data mart?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
waht is dataware house
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What is the difference between normal and bulk loading? Which one is recommended?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
How the facts will be loaded? explain
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15