1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

 1616

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

 3 11275

What is the main difference between a Joiner Transformation and Union Transformation?

 5 29944

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

 1457

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

Wipro,

1 2884

4 yrs etl devloper roles and responsibilities?any body give solutions

TCS,

1566

difference between informatica 8.1.1 and 8.6

TCS,

3236

draw informatica architecture 8.6 ?

Cognizant, TCS,

3468

complex mapping ur project u r invlve can u explain and give real time example give me ?

HGS, TCS,

1834

how to run workflow in unix?

Colgate, HP, Tech Mahindra,

5 22768

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

IBM,

9158

when informatica 8 series released ?

IBM,

1 3467

what is meant by data driven.. in which scenario we use that..?

IBM,

2 5337

My 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?

 1449

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

 2 4003

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is expression transformation?

627

Please let me know how to make Data masking in informatica..

1262

Is it possible to define a single node as a Gateway node as well as worker node?

650

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5765

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4308




What are the tasks that source qualifier perform?

629

What are the performance considerations when working with aggregator transformation?

674

Partition, what happens if the specified key range is shorter and longer

2027

What is the cumulative sum and moving sum?

752

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

601

What is meant by query override?

631

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

671

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

781

Write the unconnected lookup syntax?

652

What is decode in informatica?

648

For More Un-Answered { Informatica } Questions Click Here