How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between a connected look up and unconnected look up?
Does Facttable Normalized or Denormalized?
what happens when a batch fails?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Where do you create/define mapping parameter and mapping variable?
in which situations do u go for snowflake schema ?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?