Answer Posted / srinivas

if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice

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

4725

---

How to create or import flat file definition in to the warehouse designer?

1067

---

Differentiate between a repository server and a powerhouse?

1116

---

Explain the types of transformations?

1059

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2044

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1631

---

According to his methodology what all you need before you build a datawarehouse

1752

---

What is a pre-defined event and user-defined event?

1036

---

What is deployment group?

1203

---

update strategy transformation in informatica

1062

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2060

---

What is the sequence generator transformation in informatica?

1178

---

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

1118

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2855

---

Scheduling properties,whats the default (sequential)

1946

---