Answer Posted / grhyrngnn yjhyj
i used to stored procedure for time conversion,droping and
creating indexes,for loading time dimension,to know the
status of the database,to know the space availble.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how tokens will generate?
How to load the data from people soft hrm to people soft erm using informatica?
Target increases every day even though no new record was inserted
What is joiner change?
What is an expression transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
Differentiate between a database and data warehouse?
What is pmcmd command?
How many dimensions are there in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Is it possible to use a client with different version than that of its Informatica server?
What are the basic requirements to join two sources in a source qualifier transformation using default join?