Answer / srinu

Hi, REKHA
Can u check your answer ! Thanks for Posting.

""" A shortcut is created by assigning
'Shared' status to a folder within the Repository Manager
and then dragging
objects from this folder into another open folder"""""


If any Corrections Let me know
srinu.srinuvas@gmail.com

Answer / raj

A shortcut is a reference (link) to an object in a shared
folder these are commonly used for sources and targets that
are to be shared between different environments / or
projects. A shortcut is created by assigning 'Shared' status
to a folder within the Repository Manager and then dragging
objects from this folder into another open folder; this
provides a single point of control / reference for the
object - multiple projects don't all have import sources and
targets into their local folders. A reusable transformaion
is usually something that is kept local to a folder examples
would be the use of a reusable sequence generator for
allocating warehouse Customer Id's which would be useful if
you were loading customer details from multiple source
systems and allocating unique ids to each new source-key.
Many mappings could use the same sequence and the sessions
would all draw from the same continuous pool of sequence
numbers generated.

Answer / srini

Shortcut object will be used in across different folder
where as reusable will be valid in with in folder

Answer / rekha

U CAN USE SHOTCUTS WITH IN THE MAPPING WHERE AS REUSABLE
OBJECTS U CAN USE ACROSS MAPPINGS OF THE EPOSITORY

how to join two flat files in informatica?

3 Answers   Wipro,

---

What is the need for an etl tool?

0 Answers  

---

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

0 Answers   CTS, TCS,

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

How can you complete unrcoverable sessions?

1 Answers  

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---