Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
2 7905I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
5 9209My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
2 6488IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
IBM,
3 8039source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
5 9195source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
4 7233100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
3 11534Post New Informatica Questions
scenario where i can use only concurrent execution of workflow.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the function of look up transformation?
What is olap (on-line analytical processing?
how to create user defined function (udf) in informatica
How do you promote a non-reusable transformation to reusable transformation?
can you please explain me pre session and post session options?
What is the use of transformation?
Explain the different dimensions.
On which transformations you created partitions in your project?
What is informatica etl tool?
Slowly changing dimensions, types and where will you use them
permutations of mapplet
Which are the different editions of informatica powercenter that are available?
If informatica has its scheduler why using third party scheduler?
