What are the differences between oltp and olap?
No Answer is Posted For this Question
Be the First to Post Answer
From where we can start or use pmcmd?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
in which situations do u go for snowflake schema ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
What do you understand by a term domain?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
how to create user defined function (udf) in informatica
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source