Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
2 8033I 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 9421My 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 6593IN 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 8160source 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 9411source 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 7391100 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 11673Post New Informatica Questions
what are factless facts? And in which scenario will you use such kinds of fact tables.
How many dimensions are there in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
What is depict expression change?
What are the new features of informatica 9.x developer?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Can informatica load heterogeneous targets from heterogeneous sources?
Define update strategy?
can we override a native sql query within informatica? Where do we do it?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are some examples of informatica etl programs?
How to create or import flat file definition in to the warehouse designer?
What is workflow? What are the components of workflow manager?
What does role playing dimension mean?
What is union transformation in informatica?