what is distinct4 3561
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.4 4285
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...3 4928
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?5 4829
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Briefly explain the aggregator transformation?
What do think which one is the better joiner or look up?
4 yrs etl devloper roles and responsibilities?any body give solutions
Briefly describe lookup transformation?
Slowly changing dimensions, types and where will you use them
What does “tail –f” command do and what is its use as an Informatica admin.
What is union transformation?
What is data caches/ index caches?
what is size of u r database?
What are the different tools in workflow manager?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
When do you use sql override in a lookup transformation?
What is the use of code page?
Explain the difference between a data warehouse and a data mart?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not