Recent posts under tag informatica

+3 votes

Sequence Generator Transformation in Infotmatica

posted Jan 12, 2016 by Shivaranjini

+1 vote

1 answer

Transformations that cannot be placed between the sort origin and the Joiner transformation

posted Jan 12, 2016 by Sachin

+1 vote

1 answer

Informatica: What is a Sequence Generator Transformation?

posted Jan 12, 2016 by Amit Sharma

+1 vote

1 answer

How can we implement Aggregation operation without using an Aggregator Transformation in Informatica.

posted Jan 12, 2016 by Sunil

+3 votes

Source Qualifier Transformation in Informatica

posted Jan 11, 2016 by Shivaranjini

+2 votes

2 answers

Informatica: If Source Qualifier transformation populates two target tables, How to ensure TGT2 is loaded after TGT1?

posted Jan 11, 2016 by Sunil

+2 votes

1 answer

Out of the two input pipelines of a joiner, which one will you set as the master pipeline?

posted Jan 11, 2016 by Amit Sharma

+3 votes

1 answer

What is CDC in Informatica and what is the purpose of using it? Explain with an example?

posted Jan 11, 2016 by Sachin

0 votes

1 answer

In joiner, how to load Master table in Target?

posted Jan 8, 2016 by Sachin

0 votes

1 answer

Why you use repository connectivity?

posted Jan 8, 2016 by Amit Sharma

0 votes

1 answer

How many types transformations supported by sorted input?

posted Jan 8, 2016 by Sachin

+1 vote

2 answers

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u achieve using rank transformation ?

posted Oct 30, 2015 by Sachin

+1 vote

1 answer

How can I send half pf the records to one target and remaining to other target?

posted Oct 30, 2015 by Amit Sharma

+2 votes

1 answer

Why we use enable high precision in session properties?

posted Oct 23, 2015 by Sunil

+1 vote

1 answer

How can i catch the Duplicate Rows From Sorter Trans in a Separate Target Table ?

posted Oct 23, 2015 by Amit Sharma

+1 vote

1 answer

Explain how does QlikView storage the data internally?

posted Oct 23, 2015 by Sunil

+1 vote

1 answer

what is difference between mapping and mapplet ?

posted Oct 20, 2015 by Sunil

+1 vote

1 answer

How can you create or import flat file definition in to the warehouse designer?

posted Oct 20, 2015 by Sachin

+1 vote

1 answer

In which circumstances that informatica server creates Reject files?

posted Oct 20, 2015 by Amit Sharma

+1 vote

1 answer

How we can add header and footer to flat files?

posted Oct 14, 2015 by Sunil

+1 vote

1 answer

How can you insert one row in the target if that row does not exists in the target and update if it exists?

posted Oct 14, 2015 by Sachin

+2 votes

1 answer

I have 2 Sources, If 1st one Read sucessfully,Then only it has to move to read 2nd source? How can i do in informatica?

posted Oct 14, 2015 by Amit Sharma

+1 vote

1 answer

Can we load flatfile's data one by one to a single relational table??

posted Oct 13, 2015 by Amit Kumar Pandey

0 votes

1 answer

Using Expression transformation how to remove duplicate records from a relational source?

posted Oct 13, 2015 by Sunil

0 votes

1 answer

How to convert flat file into xml file? How to tune joiner?

posted Oct 13, 2015 by Sachin

+1 vote

1 answer

How will you find weather dimension table is big in size of a fact table?

posted Oct 13, 2015 by Amit Sharma

0 votes

1 answer

How will you get 21 to 30 record from 50 records?

posted Oct 9, 2015 by Sunil

+2 votes

1 answer

What is the difference between Informatica 7.1 and Abinitio?

posted Oct 9, 2015 by Sachin

+1 vote

1 answer

How to enter same record twice in the target table, explain?

posted Oct 9, 2015 by Amit Sharma

+1 vote

1 answer

Dependency Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

posted Oct 7, 2015 by Sachin

+1 vote

2 answers

What are the different tasks that can be created in workflow manager?

posted Oct 7, 2015 by Sachin

+1 vote

1 answer

What are the different types of Type2 dimension mapping?

posted Oct 7, 2015 by Amit Sharma

+1 vote

1 answer

How many number of sessions that you can create in a batch?

posted Oct 5, 2015 by Sunil

0 votes

1 answer

How to generate the HTML output using Informatica?

posted Oct 5, 2015 by Sachin

+1 vote

1 answer

Informatica: My source having 10 records but how can I load 20 records in target, I am not bother about duplicates?

posted Oct 5, 2015 by Amit Sharma

+2 votes

0 answers

What are the transformations that are used in data cleaning ? and how data cleansing takes place ?

posted Sep 30, 2015 by Sunil

+1 vote

1 answer

Can u apply SCD2 on flat file tgt? if yes what is the procedure?

posted Sep 30, 2015 by Sachin

+1 vote

1 answer

What is metadata reporter?

posted Sep 30, 2015 by Amit Sharma

+1 vote

1 answer

What is the difference between onsite & client site in Informatica?

posted Sep 28, 2015 by Sunil

+2 votes

1 answer

How can we use sorter transformation in joins?

posted Sep 28, 2015 by Sachin

+2 votes

1 answer

How can you recover the session in sequential batches in Informatica?

posted Sep 28, 2015 by Amit Sharma

0 votes

1 answer

What are the Unix commands to start the work flow ?

posted Sep 24, 2015 by Sunil

0 votes

1 answer

List the transformation in informatica?

posted Sep 24, 2015 by Sachin

0 votes

1 answer

How many mapplets you have created? and what is the logic used?

posted Sep 24, 2015 by Amit Sharma

+3 votes

1 answer

How to load last 10 records of flat file in to the target?

posted Sep 21, 2015 by Sunil

+2 votes

1 answer

What is a target load order?

posted Sep 21, 2015 by Sachin

+2 votes

1 answer

What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?

posted Sep 21, 2015 by Amit Sharma

+1 vote

1 answer

What are the ETL tools available in DWH?

posted Sep 19, 2015 by Sunil

0 votes

1 answer

Informatica: Can a port in expression transformation be given the name DISTINCT?

posted Sep 19, 2015 by Sachin

+2 votes

1 answer

Why cant we put a sequence generator or update strategy transformation before joiner transformation?

posted Sep 19, 2015 by Amit Sharma