how to load dimension table and fact table. plz tell me the
steps.
No Answer is Posted For this Question
Be the First to Post Answer
Under which circumstances, informatica server creates reject files?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
what is difference between dimention table and fact table?
create a mapping to retrieve the employees who are getting salary greater than average salary?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Why you use repository connectivity?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
how to join the two flatfiles using the joiner t/r if there is no matching port?
What are Target Options on the Servers?
What does command task mean?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me