Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
2 7897I 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 9203My 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 6483IN 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 8024source 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 9186source 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 7220100 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 11523Post New Informatica Questions
What is the scenario which compels informatica server to reject files?
Define pmcmd command?
How to join three sources using joiner? Explain though mapping flow.
How do you load unique records into one target table and duplicate records into a different target table?
What is the reusable transformation?
What is the procedure for creating independent data marts from informatica 7.1?
How to create the source and target database connections in server manager?
What is joiner transformation in informatica?
Explain pmcmd command usage in informatica
Explain the tuning lookup transformation - informatica
How we can create indexes after completing the loan process?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the sequence generator transformation in informatica?
can u give example for factless fact table
How can we handle two sessions in informatica?