Why Union transformation is active while it returns same number of rows as in the sources?
Latest Answer: Hi,Please make a note that there is no option available in a Union transformation to handle duplicates.It does a 'UNION ALL'. If handling of duplicates is the requirement then Sorter can be used. ...
What is the main data object present in between Source and Target.
Latest Answer: Stage..where we can transform the source data and will load into TGT.Thx SRIRAM N ...
What is meant by source is changing incrementally?Explain with an example?
Latest Answer: The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N ...
What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?
Latest Answer: Suppose during one process a file is generated in one path and during the running of the worflow you want it to place in another path, so for this we need to use unix command "cp soure pathname targt pathname".Generally all informatica jobs ...
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
Latest Answer: Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records ...
Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
Latest Answer: How would you know whether the server commited or not? You can run the session again by setting the recovery opton enable and recover the session..which starts processing from the point where it was stopped..but for your information we generally don't ...
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
Latest Answer: hi i think it is of 2 ways you can find.1. a) find out how many number of rows are there in the source using basic sql query. e.g select * from source_table. b) execute the work flow. in that ...
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps
Latest Answer: If you configure a session in a sequential batch to stop on failure,you can run recovery starting with the failed session.The Infomatica server completes the session and then runs the rest of the batch.If you donot configure a session in a sequential ...
What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .
Latest Answer: Mapping variable can change(increment) for every time session runs where as parameter does not change.If u give a mapping variable once it ll stores in reposotory n next time when u run the session it ll increment by which u setup the value to increment ...
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
Latest Answer: In order to boost performance always choose the tabel with lesser rows to be the master table ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
