Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shashiall
Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
What is exclusive and normal mode for repository services?
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. ?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain the features of connected and unconnected lookup.
How are the sources and targets definitions imported in informatica designer?
What are the components of workflow manager?
What is the Rank index port in Rank transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How many ways a relational source definition can be updated and what are they?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Enlist few areas or real-time situations where informatica is required.
