Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

in realtime which situations u can use unconnected lookup transformation

Patni,

2 6143

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

Patni,

3 7507

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

TCS,

2 3362

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

TCS,

2 4693

How informatica process data means how informatica works?

TCS,

2 11203

Can we run session without using workflows?

TCS,

5 17118

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 5791

what is the location of parameter file in informatica?

TCS,

1 6778

what is runtime variable?

TCS,

3 4967

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

TCS,

6 8463

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

TCS,

1971

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

TetraSoft,

6 10882

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 8309

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 5217

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

Cognizant, Flextronics,

1341


Post New Informatica Questions






Un-Answered Questions { Informatica }

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1552


What is enterprise data warehousing?

219


How to generate or load values in to the target table based on a column value using informatica etl tool.

231


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

3943


What are the popular informatica products?

227






Explain direct and indirect flat file loading (source file type) - informatica

276


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

807


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1202


How to update or delete the rows in a target, which do not have key fields?

224


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

221


Explian the connected and unconnected lookup transformation

245


How can you validate all mappings in the repository simultaneously?

263


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?

218


Differentiate between sessions and batches?

212


Design a mapping to load the cumulative sum of salaries of employees into target table?

280