can we override a native sql query within informatica? How do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
scenario
Discuss the advantages & Disadvantages of star & snowflake schema?
in realtime which situations u can use unconnected lookup transformation
how do u use sequence created in oracle in informatica? Explain with an simple example
explain different types of modeling.
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
why we r using presql&postsql in source qualifier?
What happens when a session fails and you click on recover?
expain about the tune parameters?