error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
4 5092source 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.
TCS,
4 7638Is 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 5717When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
5 6062What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
TCS,
2 12727Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
IBM,
3 7141How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
IBM,
4 8821Post New Informatica Questions
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a stored procedure transformation?
Did u used latest transformations of 8.6.0? for what?
What is a shortcut and copy in Informatica and how two are different with each other?
How to load last n records of file into target table - informatica
Difference between Target-based loading and constraint-based loading?
update strategy transformation in informatica
Briefly define a session task?
Explain the features of connected and unconnected lookup.
What is main use of mapplet?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain about cumulative Sum or moving sum?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to load a Dimension ? and how to load a fact table?
What are the differences between source qualifier and joiner transformation?