What are mapplets? How is it different from a Reusable Transformation?
No Answer is Posted For this Question
Be the First to Post Answer
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Explain one complecated mapping?
What do mean by local and global repository?
how to join the two flatfiles using the joiner t/r if there is no matching port?
How to convert multiple rows to single row (multiple columns) in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is a shortcut and copy in Informatica and how two are different with each other?
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?
What are the settings that you use to configure the joiner transformation?
How to load data in informatica ?