Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
2 7783I 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 9013My 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 6371IN 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 7875source 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 9001source 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 7071100 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 11388Post New Informatica Questions
What does command task mean?
What do mean by local and global repository?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain informatica architecture - version 8 / 9
Name the different lookup cache(s)?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a repository? And how to add it in an informatica client?
In which transformation you cannot drag ports into it?
What will be the approach?
scenario where i can use only concurrent execution of workflow.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to implement security measures using repository manager?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What do you mean by enterprise data warehousing?
Does an informatica transformation support only aggregate expressions?