Answer Posted / abhik mazumdar

Hi Mukesh,

This is Abhik
Could you please provide dumps what you have,as I am planing to attend certification, if you provide
dumps it will be more helpfull to me.

My personal email id : argha87sphs@gmail.com

Thanks
Abhik

What is olap (on-line analytical processing?

1074

---

What is data movement mode in Informatica and difference between them?

1142

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

---

What is the format of informatica objects in a repository?

1021

---

How to elaborate tracing level?

1184

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1285

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1128

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1812

---

What is sorter transformation?

1055

---

Explain your project of banking domian.

1654

---

Please let me know how to make encryption and decryption with example?

1908

---

How can a transformation be made reusable?

1174

---

Different sorts of metadata that stores in the storage facility?

1017

---

What are connected or unconnected transformations?

1128

---

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

4167

---