Which is better performance wise database or file?How?
Answer Posted / gyana
flat files are good for performance....
but fixed width files are more better than a delimited flat file......
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
tell me the rules and responsblites in our project(my project is development)
What is blocking transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is joiner transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How is union transformation utilized?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What does role playing dimension mean?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the types of schemas we have in data warehouse and what are the difference between them?
What you know about transaction control transformation?