Answer Posted / ankit gaur

Hi,
If any one have informatica certification dumps,kindly send it to my email: ankitgaur.212@gmail.com

Target increases every day even though no new record was inserted

1513

---

Differentiate between a repository server and a powerhouse?

1041

---

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

4067

---

What is a joiner transformation and why it is an active one?

995

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1175

---

What are the different components of powercenter?

986

---

What is the scenario which compels informatica server to reject files?

1006

---

What is the command used to run a batch?

993

---

How many dimensions are there in informatica?

1022

---

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?

6353

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1197

---

How does a sorter cache works?

999

---

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

6909

---

Whats there in global repository

1641

---

Differentiate between joiner and lookup transformation?

1045

---