Recent posts under tag informatica

+2 votes

3 answers

A table contains some null values. How to get (Not Applicable(NA)) in place of that null value in target?

posted Jul 31, 2015 by Sunil

0 votes

1 answer

What is the difference between informatica versions 8.1.1 and 8.6.1?

posted Jul 31, 2015 by Sachin

+1 vote

1 answer

How to run two workflow (not a sessions) sequentially in Informatica, what is the process?

posted Jul 31, 2015 by Amit Sharma

0 votes

1 answer

What is file list concept in informatica?

posted Jul 28, 2015 by Sunil

0 votes

1 answer

What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?

posted Jul 28, 2015 by Sachin

0 votes

1 answer

Informatica: How do u get the first record from 50,000 records?

posted Jul 28, 2015 by Amit Sharma

+2 votes

2 answers

Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

posted Jul 24, 2015 by Sunil

+2 votes

1 answer

What are two types of processes that informatica runs the session?

posted Jul 24, 2015 by Sachin

+1 vote

1 answer

Informatica: How do u get the first record from n records say 50,000?

posted Jul 24, 2015 by Amit Sharma

+1 vote

1 answer

What is the version controlling in informatica?

posted Jul 22, 2015 by Sunil

+2 votes

1 answer

What are the differences between joiner transformation and source qualifier transformation?

posted Jul 22, 2015 by Sachin

+1 vote

1 answer

Informatica: If session fails after loading 10000 records in the target, how can we load 10001 the record when run next?

posted Jul 22, 2015 by Amit Sharma

+1 vote

1 answer

In informatica, if i have some number of records, if i want 1st and 10th records, What will be the method to use?

posted Jul 20, 2015 by Sunil

0 votes

1 answer

What is the logic will you implement to load data into a fact table from dimension tables?

posted Jul 20, 2015 by Sachin

+1 vote

1 answer

Why is meant by direct and indirect loading options in sessions?

posted Jul 20, 2015 by Amit Sharma

+1 vote

1 answer

What are the session parameters?

posted Jul 16, 2015 by Sunil

0 votes

1 answer

How to run the batch using pmcmd command?

posted Jul 16, 2015 by Sachin

+1 vote

0 answers

How to do data modeling in Tableau?

posted Jul 16, 2015 by Amit Sharma

+1 vote

1 answer

How do you perform incremental load?

posted Jul 14, 2015 by Sunil

+1 vote

1 answer

How to get the latest data in SCD?

posted Jul 14, 2015 by Sachin

+1 vote

1 answer

How the informatica server sorts the string values in Rank transformation?

posted Jul 14, 2015 by Amit Sharma

+2 votes

1 answer

How the informatica server sorts the string values in Rank transformation?

posted Jul 13, 2015 by Sunil

+2 votes

1 answer

What are partitions in informatica and which one is used for better performance?

posted Jul 13, 2015 by Sachin

+2 votes

1 answer

How you know when to use a static cache and dynamic cache in lookup transformation?

posted Jul 13, 2015 by Amit Sharma

+1 vote

0 answers

In which situations do you go for star flake schema ?

posted Jul 9, 2015 by Sunil

+1 vote

1 answer

What is casual dimension?

posted Jul 9, 2015 by Sachin

+1 vote

1 answer

What is upstream and downstream transformation?

posted Jul 9, 2015 by Amit Sharma

+1 vote

1 answer

What is a DTM process in context of Informatica?

posted Jul 6, 2015 by Sunil

+1 vote

1 answer

How to compare two DB having same structure different data?

posted Jul 6, 2015 by Sachin

+1 vote

1 answer

How to list Top 10 salary, without using Rank Transmission?

posted Jul 6, 2015 by Amit Sharma

+3 votes

1 answer

How many repositories can we create in Informatica?

posted Jul 2, 2015 by Sachin

0 votes

1 answer

What is tracing level and what are the types of tracing level?

posted Jul 2, 2015 by Sunil

+2 votes

1 answer

Informatica: Difference between star and snowflake schema?

posted Jul 2, 2015 by Amit Sharma

+1 vote

1 answer

What is the difference between Bitmap and Btree index?

posted Jun 25, 2015 by Sunil

+2 votes

1 answer

How to load only the first and last record of a flat file into the target?

posted Jun 25, 2015 by Sachin

+1 vote

1 answer

What is Throughput in Informatica, How it works, Where I can find this option to check ?

posted Jun 25, 2015 by Amit Sharma

0 votes

1 answer

What is sales project in informatica?

posted Jun 23, 2015 by Sunil

+2 votes

1 answer

Informatica: Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?

posted Jun 23, 2015 by Sachin

+3 votes

1 answer

Informatica: What is tracing level and what are the types of tracing level?

posted Jun 23, 2015 by Amit Sharma

+1 vote

1 answer

What are the reusable tasks in informatica ?

posted Jun 10, 2015 by Sunil

+1 vote

1 answer

How to delete duplicate record in Informatica?

posted Jun 10, 2015 by Sachin

+1 vote

1 answer

What are slowly changing dimensions?

posted Jun 10, 2015 by Amit Sharma

+2 votes

1 answer

What is update strategy transformation ?

posted Jun 8, 2015 by Sunil

+1 vote

1 answer

How do you implement scheduling in informatica?

posted Jun 8, 2015 by Sachin

+1 vote

2 answers

What is operational data source (ODS)?

posted Jun 8, 2015 by Amit Sharma

+1 vote

1 answer

What is incremental loading in Informatica?

posted Jun 1, 2015 by Sunil

0 votes

1 answer

What are Dimensions and various types of Dimensions in context of Informatica?

posted Jun 1, 2015 by Sachin

+1 vote

1 answer

How many tasks are there in informatica ?

posted Jun 1, 2015 by Amit Sharma

+1 vote

1 answer

What are the different types of schemas in context of Informatica?

posted May 27, 2015 by Sunil

+1 vote

1 answer

Explain about HLD and LLD in context of Informatica?

posted May 27, 2015 by Sachin