How are parameters defined in informatica?
Answers were Sorted based on User's Feedback
parameters are defined in a mapping parameter/variables wizard.we can pass the values to the parameter outside the mapping without disturbing the design of mapping,but parameters are constant,until and unless user changes
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jagan
Value of mapping parameter remain constant for a session run. Server reads its value on every run from parameter file. its value can not be changed at the time of session execution. When ever next time session runs, it reads the parameter value again from parameter file.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / upendra
mapping parametrs are constant, if we define the mapping parameters and variable to mapping tab on menu bar, it used to every time we can run session edit the parameter file, we cant disturb mapping in design
Is This Answer Correct ? | 0 Yes | 0 No |
what is procedure to use mapping variable in source qualifier transformation? with example
What are the advantages of informatica?
explain different types of modeling.
How can you increase the performance in joiner transformation?
What is the cumulative sum and moving sum?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
How can we create index after completion of load process?
What do you understand by SOA of Informatica?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is data merging, data cleansing and sampling?