Answer Posted / nagaraju

count(*) from table;

What is mapplet in informatica?

1124

---

Where do we use mapping variables in informatica?

1120

---

What is flashback table ? Advance thanks

1998

---

How to load last n records of file into target table - informatica

1132

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2086

---

Under which circumstances, informatica server creates reject files?

1139

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1711

---

what are the Methods For Creating Reusable Transformations?

1253

---

Is it possible to use a client with different version than that of its Informatica server?

1189

---

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

1315

---

Global and Local shortcuts. Advantages.

2089

---

Explian the Process of deployment groups in informatica

1102

---

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?

1957

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1129

---

How to convert multiple rows to single row (multiple columns) in informatica

1425

---