why do u use shortcuts in informatica.?
Answers were Sorted based on User's Feedback
Answer / sundar
Short cut is used create copy of the object in shared
folder,that copied folder inherit changes.It maintains same
repository.
Is This Answer Correct ? | 16 Yes | 2 No |
Answer / veera
Shortcut is a concept of reusability.If there is a mapping
that can be reused across several folders, create it in one
folder and use shortcuts of it in other folders. Thus, if
you have to make change, you can do it in main mapping
which reflects in shortcut mappings automatically.
Is This Answer Correct ? | 15 Yes | 8 No |
Answer / sarvesh
shrt cut provides the easiest way to reuse the
objects,shrtcut created only in shared folder ,and it if
uwants to reuse the object in ur folder,then go to shared
folder and drag into ur local folder,in this way u can
create short cuts.
This is as for my knowledge.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / laxman sane
short cut prvides the easiest way the to reuse the
objects, shoprt cut cammand we help the computer the create
only in shared folder.
Is This Answer Correct ? | 2 Yes | 6 No |
Can we change Dynamic to Static or Persistent cache? If so what happens?
we have to use order by,where,having we to implement sql query
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What are the restrictions of union transformation?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Why update strategy and union transformations are active? Explain with examples.
what is diff between grep and find
What is confirmed dimension?