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

in realtime which situations u can use unconnected lookup transformation

Patni,

2 7177

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

Patni,

3 8537

i have source in oracle 10g,oracle 8i how will u take the data from two sources

TCS,

2 4154

why we are using surogate key in real time give me explanation

TCS,

2 5831

How informatica process data means how informatica works?

TCS,

2 12097

Can we run session without using workflows?

TCS,

5 20109

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

HCL, HP,

2 6806

what is the location of parameter file in informatica?

TCS,

1 7634

what is runtime variable?

TCS,

3 6141

which is better perfomancewise lookup or joiner and why?can anyone give example?

TCS,

6 10116

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2386

How to delete first 3 rows & last 3 rows in target table in informatica

TetraSoft,

6 12755

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9025

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

Cognizant, Flextronics,

3 6710

what is the size ur source like(file system or database)? how many record daily come u r banking project?

Cognizant, Flextronics,

1744

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a joiner transformation?

549

Define joiner transformation?

589

can we override a native sql query within informatica? How do we do it?

644

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3441

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1864




I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

596

Why update strategy and union transformations are active? Explain with examples.

703

How many types of sessions are there in informatica.please explain them?

674

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1584

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527

What is Cognos script editor?

3782

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1619

Parameter and variable differences

1613

Is it possible to revert a global repository to local one and why?

611

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1744

For More Un-Answered { Informatica } Questions Click Here