Answer Posted / guest

yes we can........ dont mention any primary key in target
table. use target load as bulk mode in session and run it..

What is event and what are the tasks related to it?

1054

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2119

---

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?

1851

---

What is the need of etl tools?

1052

---

permutations of mapplet

2454

---

Whats there in global repository

1641

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1840

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2075

---

Briefly define reusable transformation?

1075

---

How do you load alternate records into different tables through mapping flow?

1802

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1805

---

To import the flat file definition into the designer where should the flat file be placed?

1005

---

How does a sorter cache works?

1000

---

waht type of interface is used for testing the data in informatica

2191

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1026

---