Answer Posted / nagaraju bhatraju

if your flat file are of same structure then analyze any
one of the file in sourceanalyzer of informatica,and
proceed with mapping development, hence you will have only
one mapping, but make all other flat file entries into
other file along with their exact path of files and save
this indexfile or file with all files entires with .dat.

and give this file name in source file directory or source
file and change load type from direct to indirect, hence
all the 365 files will be loaded in to the singe target ,
with single mapping , this concept will be called as file
list or file repository .

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. ?

2084

---

Did u used latest transformations of 8.6.0? for what?

1924

---

Explain the difference between mapping parameter and mapping variable?

1079

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170

---

Define sessions in informatica etl?

1101

---

What are mapplets? How is it different from a Reusable Transformation?

1134

---

define galaxy repository in informatica

2285

---

What is a joiner transformation?

1035

---

Can you generate sequence numbers without using the sequence generator transformation?

1160

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289

---

What is the sequence generator transformation in informatica?

1262

---

What is an expression transformation in informatica?

1089

---

Explain sessions. Explain how batches are used to combine executions?

1077

---

How can we update a record in the target table without using update strategy?

1201

---

How can a transformation be made reusable?

1227

---