Most answered questions under tag informatica

+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

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

+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

0 votes

1 answer

Informatica: How to pass unique values to one table and duplicate values to another one in a single mapping?

posted Sep 16, 2015 by Sunil

+1 vote

1 answer

Informatica: Which gives more performance when compare to fixed width and delimited file ? and why?

posted Sep 16, 2015 by Amit Sharma

+1 vote

1 answer

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

posted Sep 15, 2015 by Sunil

+1 vote

1 answer

What is the Rank index in Rank transformation?

posted Sep 15, 2015 by Sachin

+1 vote

1 answer

What are the options in the target session of update strategy transformation?

posted Sep 15, 2015 by Amit Sharma

+1 vote

1 answer

What is Data driven?

posted Sep 14, 2015 by Sunil

+1 vote

1 answer

What are the options in the target session of update strategy transformation?

posted Sep 14, 2015 by Sachin

0 votes

1 answer

How the server recognizes , if the session fails after loading the 100 records in to the target?

posted Sep 14, 2015 by Amit Sharma

+1 vote

1 answer

What are the different types of modeling in Informatica?

posted Sep 9, 2015 by Sachin

+1 vote

1 answer

Informatica: Without source how to insert record to target?

posted Sep 9, 2015 by Amit Sharma

0 votes

1 answer

What is rank and dense rank in informatica with any examples and give sql query for this both ranks?

posted Sep 8, 2015 by Sunil

0 votes

1 answer

What are the joiner caches?

posted Sep 8, 2015 by Sachin

0 votes

1 answer

In operator is used in which transformation in informatica 8.6.0?

posted Sep 4, 2015 by Sunil

+1 vote

1 answer

Difference between persistence and dynamic caches? On which conditions we are using these caches?

posted Sep 4, 2015 by Sachin