Answer Posted / sarthak

With the help of command task...

cd dir_path
cat 1st_filename 2nd_filename >> 3rd_filename

Then,

create 1 flatfile and connect it to target.

In session property,
give the filename: 3rd_filename and its path

define galaxy repository in informatica

2231

---

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?

6493

---

What is the sequence generator transformation in informatica?

1184

---

What are the settings that you use to configure the joiner transformation?

1055

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2162

---

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?

1932

---

What are the different components of powercenter?

1055

---

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

1139

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1964

---

Enlist few areas or real-time situations where informatica is required.

1088

---

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

4164

---

What is meant by a domain?

1130

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10174

---

Explain constraint based loading in informatica

1098

---